﻿using ERP_RORZE_DLL.Product.Base;
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace ERP_RORZE_PRODUCT.Product.DAO
{
    class ReportDAO : ExecuteSQL
    {
        ExecuteSQL Execute = new ExecuteSQL();

        public DataTable GetWTSNG(DateTime FromDate, DateTime ToDate)
        {
            var parameter = new SqlParameter[]
                {
                    CreateParameter("@From", SqlDbType.DateTime, FromDate),
                    CreateParameter("@To", SqlDbType.DateTime, ToDate)
                };
            string sql = clsConstantsFuction.ClsFuctionReport.GetAllWTSNG;
            return Execute.DoStoreGetByID(sql, parameter, true);
        }
    }
}
